import pytest
from API_wms.utils.excel import ExcelUtils
from API_wms.config.RequestClient import *
from API_wms.utils.Jdbc import *


@pytest.fixture(scope='session')
def excel():
    excel = ExcelUtils(r'C:\Users\34098\PycharmProjects\Auto_wms\API_wms\data\canshu.xlsx',"Sheet1")
    yield excel
    excel.close()

@pytest.fixture(scope='class')
def api():
    api = RequestClient("http://10.59.9.12:7001", 10)
    yield api

@pytest.fixture(scope='class')
def jdbc():
    jdbc = Jdbc(host='10.59.9.12',user="root",password="yidong666",database="a3mall")
    yield jdbc
    jdbc.close()